package com.huadi.bili_hot.dao.mapper;

import com.huadi.bili_hot.entity.Toprank;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface ToprankMapper {
    @Select("select * from topranking where type = \"新番\" order by rank")
    List<Toprank> selectBangumiList();

    @Select("select * from topranking where type = \"电影\" order by rank")
    List<Toprank> selectMovieList();

    @Select("select * from topranking where type = \"电视剧\" order by rank")
    List<Toprank> selectTvseriesList();

    @Select("select * from topranking where type = \"主站\" order by rank")
    List<Toprank> selectHostList();
}
